package com.wolf.repository;

import com.wolf.pojo.Wl_coupon;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface Wl_couponMapper {
    int deleteByPrimaryKey(String id);

    int insert(Wl_coupon record);

    int insertSelective(Wl_coupon record);

    Wl_coupon selectByPrimaryKey(String id);

    int updateByPrimaryKeySelective(Wl_coupon record);

    int updateByPrimaryKey(Wl_coupon record);

    /**
     * 查询所有
     */
    List<Wl_coupon> getAll();

    /**
     * 优惠卷管理页面商品分类
     */
    List<Wl_coupon> getByCateName();

    /**
     * 优惠卷管理页面活动状态
     */
    List<Wl_coupon> getByStatus();


    /**
     * 模糊查询
     */
    List<Wl_coupon> fuzzyQuery(@Param("starttime") String starttime, @Param("expiretime")String expiretime, @Param("categoryid")String categoryid, @Param("couponname")String couponname, @Param("couponcode")String couponcode, @Param("status")String status);

}